Importation des 3 fichiers CSV

On construit 4 colonnes de plus :

On crée df_games2 qui ne contient que les jeux ayant à la fois une note globale utilisateur et une note globale de critique

On affiche la distribution des ratios "nombre de critiques / nombre de revues utilisatuer". On voit que la grande majorité des ratio est inférieure à 1, montrant qu'il y a plus de participation des utilisateurs. On pourrait parler du pic de la distribution (du mode) pour avoir une idée du ratio moyen.

Ici un graphe qui montre la distribution des scores meta pour chaque console. Ça se ressemble. Petite tendance qui se dégage : les consoles les plus récentes (Series X et PS5) sont plus distribuées vers les notes hautes. (Pour information, la limite droite de chaque boite indique le 3ème quartile, c'est à dire que 25% des notes sont supérieures)

General

Which console has more games titles ?

Je regarde combien de critiques sont faites par chaque organe identifié dans Metacritique. On comprend ici que TheXboxHub a produit 3923 critiques, Nintendo Life 3864...

Given release date let's add two columns with year and month information

EA Sports appears also as 'EA Sports, EA Vancouver' and 'EA Vancouver'. Let's unify the names

In order to perform analysis related to scores, we need to use those games with reviews

Which console has best average scores ?

Let's compare metacritics scores vs user scores. (metacritics scores are made by specialized critics sites while user scores by people registered on metacritic.com)

Meta scores tend to be higher than user scores

We confirm that there are more 'Generally favorable reviews' in meta scores and more 'Generally unfavorable reviews' in user scores.
Users tend to be more critic in their reviews than specialized sites (paid reviews ?)

How many new titles were released since 2014 ?

Here we compare just PlayStation 4 and Xbox One because both platforms were announced the same year (2013). On the other hand Nintendo Switch in 2016

When are new titles released ?

There's a peak between August and November (anticipating christmas sales?)

How did average scores evolve since 2014 ?

No big changes

Best games

How many titles per console have metacritic score greater than 85?

How many titles per console have user score greater than 85?

Let's add a column with the difference between meta and user score

PlayStation 4

What are the best 20 titles according to metacritic score?

For a lot of those titles there's a big difference between what meta critics and users think

What are the best 20 titles according to user score?

With exception of AO Tennis, meta critics and users scores seem to be similar

What are the top 10 titles most overrated by metacritic? (user point of view)

What are the top 10 titles most underrated by metacritic? (user point of view)

Let's see more information about AO Tennis

It's a new game with few critics reviews

Exclusive games

PlayStation 4

How many exclusive games PlayStation 4 got?

What are the top 25 exclusives PlayStation 4 games?

How many exlusive PlayStation 4 games have user score equal or greater than 80 ?

Xbox One

How many exclusive games Xbox One got?

What are the top 25 exclusives Xbox One games?

How many exlusive Xbox One games have user score equal or greater than 80 ?

Switch

How many exclusive games Switch got?

What are the top 25 exclusives Switch games?

How many exlusive Switch games have user score equal or greater than 80 ?

Developers

PlayStation 4

Who are the top 10 developers with more released titles?

Does quantity mean quality?

It seems that not

Who are the best 10 developers according to user score (at least 4 released titles)?

What are the titles that gave them such a good reputation ?

From Software

DONTNOD Entertainment

Who are the top 10 developers whose titles are on average more overrated by metacritic (at least 4 released titles) ?

What are the top 10 EA Sports games according to metacritic?

Who are the top 10 developers whose titles are on average more underrated by metacritic (at least 4 released titles)?

Ratings

How many titles per rating category?

E: Everyone
E+10: Everyone +10
T: Teen +13
M: Mature +17

Which console is more "family" oriented?

Switch has in proportion more games suited for everyone

Which category has the best games ?

Mature category seems to has an advantage